PostgreSQL Replication, Second Edition

PostgreSQL Replication, Second Edition postgresql create replication slot pg_create_logical_replication_slot() is a system function for creating a logical replication slot pg_create_logical_replication_slot() was added in PostgreSQL postgresql create replication slot Improve WAL archiving and streaming replication using replication slots PostgreSQL and later come with a feature called “replication slots”

postgresql create replication slot pg_create_physical_replication_slot() is a system function for creating a physical replication slot pg_create_physical_replication_slot() was added in

postgresql replication slot You can configure multiple receivers for a replication slot, since the slots are unaware of the state of the receiver Multiple receivers can be When creating a subscription, the replication slot already exists In that case, the subscription can be created using the create_slot = false option to